@echo off
echo Update hnl database with a dump batch by Parkin
set sqlFile=sqlDmp_%date:~0,10%.sql
set sqlFile=%sqlFile:/=_%
set dbname=hnl
cd /d C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin
mysqldump.exe %dbname% --user=root --password=2wsx#EDC> C:\HNLbackup\DB\%sqlFile%
echo Backup completed.